﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

INSERT INTO [dbo].[Customers]([FirstName],[LastName],[Road],[ZipCode],[City],[Country],[Telephone],[Mobi],[Email],[Birthday])
     VALUES('Nam','Nguyen','42 Dai Lo 2','084','Ho Chi Minh','Viet Nam','','0988883397','hoainam3003@hotmail.com','3/30/1985')
GO

INSERT INTO [dbo].[Customers]([FirstName],[LastName],[Road],[ZipCode],[City],[Country],[Telephone],[Mobi],[Email],[Birthday])
     VALUES('Thu','Thuy','42 Dai Lo 2','084','Ho Chi Minh','Viet Nam','','0988883397','thuthuy@hotmail.com','3/30/1985')
GO

alter TABLE [dbo].[Customers] add 
	[HomeTel]  NCHAR (15)     NULl
   


